# -*- mode: snippet -*-
# name: proc import
# key: import
# --

proc import datafile="d:/project/`(nth 2 (split-string (file-name-directory (expand-file-name (buffer-name))) "/"))`$0"
out=${1:}
dbms=xlsx replace;
sheet='$2';
getnames=yes;
run;

data $1_1;
set $1;
rename VAR1=subjid;
run;
proc sort data=$1_1;
by subjid;
run;
